Evaluate(Object[]) Method

In This Topic

Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.

Syntax

'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As Object _
) As Object

'Usage
 
Dim instance As CalcOffsetFunction
Dim args() As Object
Dim value As Object
 
value = instance.Evaluate(args)

public override object Evaluate( 
   object[] args
)

args

The args contains 3 - 5 items: reference, rows, cols, [height], [width].

Reference is the reference from which you want to base the offset.

Rows is the number of rows, up or down, that you want the upper-left cell to refer to.

Cols is the number of columns, to the left or right, that you want the upper-left cell of the result to refer to.

[Height] is the height, in number of rows, that you want the returned reference to be. Height must be a positive number.

[Width] is the width, in number of columns, that you want the returned reference to be. Width must be a positive number.

A GrapeCity.CalcEngine.CalcReference value that indicates the evaluate result.